﻿CREATE TABLE [dbo].[TOCHUC] (
    [IdDoiTuong]         UNIQUEIDENTIFIER NOT NULL,
    [MaHieu]             NCHAR (100)      NOT NULL,
    [MaChuQuan]          NCHAR (100)      NULL,
    [TenToChuc]          NVARCHAR (MAX)   NOT NULL,
    [Loai]               NCHAR (100)      NULL,
    [LinhVuc]            INT              NULL,
    [SLNhanVien]         NCHAR (100)      NULL,
    [DoanhThuNam]        NCHAR (100)      NULL,
    [MaSoThue]           CHAR (100)       NULL,
    [NganHang]           NVARCHAR (MAX)   NULL,
    [DienGiai]           NVARCHAR (MAX)   NULL,
    [Tel]                CHAR (50)        NULL,
    [Fax]                CHAR (50)        NULL,
    [Email]              CHAR (100)       NULL,
    [Website]            NCHAR (100)      NULL,
    [DanhGia]            NCHAR (100)      NULL,
    [LoaiSoHuu]          NCHAR (100)      NULL,
    [MaChungKhoan]       CHAR (100)       NULL,
    [NgayLapToChuc]      DATETIME         NOT NULL,
    [IdDiaChiThanhToan]  INT              NULL,
    [IdDiaChiChuyenHang] INT              NULL
);







